USE N'<Database Name, NVARCHAR(MAX), >'
GO

/****** Object:  StoredProcedure [dbo].[ExtendedProperties_Table_Index]    Script Date: 2/5/2015 1:58:59 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


/******************************************************************************************
Procedure Name: ExtendedProperties_Table_Index

Purpose: Adds/Updates extended property information for table index

Parameters: 
    @schema		sysname	   The Schema of the object
    @table_name	sysname	   The name of the table
    @index_name	sysname	   The name of the index
    @desc			sql_variant  The description to add/update.
  
History:
    09/03/2014		AkersMa	   Initial release  
******************************************************************************************/


CREATE PROCEDURE [dbo].[ExtendedProperties_Table_Index] ( @schema	sysname, @table_name	sysname, @index_name	sysname, @desc	sql_variant) AS
	EXEC ExtendedProperties_Object @desc, N'Schema', @schema, N'Table', @table_name, N'Index', @index_name;
	RETURN (0);
GO


